UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'eUEuV5MkdLGUBOULlLyvREU1PdVlPMww4L4fmij5kWk='
WHERE
key_id = '0bc8e71b190f40284b8f04742bd11c21b249ced5b552e27a3ba7684592fd3341'
AND (
token = 'eUEuV5MkdLGUBOULlLyvREU1PdVlPMww4L4fmij5kWk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)