UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'e8lvdrbYzHWF3rCJ0xYhEjX0+U+OjQHO6JrAaU1TwEk='
WHERE
key_id = '235fdc9b5884e26efb463c56c852e0114117390daec69d304c06f07ab759b1df'
AND (
token = 'e8lvdrbYzHWF3rCJ0xYhEjX0+U+OjQHO6JrAaU1TwEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)