UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'IDiwXzbhx6wiXsGJk8PLslfF1BiC1omUKBUorYfvy74='
WHERE
key_id = '485cab2398c0c573e3e3e0c61a99a1f3ea11ff4ad30ff260535e9fc03ec5cdbf'
AND (
token = 'IDiwXzbhx6wiXsGJk8PLslfF1BiC1omUKBUorYfvy74='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)