UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XmvfLY5T19IGhQj7xq+47lmuSxz3n82fkYhAavqymbs='
WHERE
key_id = '1ef0fac5cad2fca122c660477f9651a10b5d27e21443e210d1dcba45ea434554'
AND (
token = 'XmvfLY5T19IGhQj7xq+47lmuSxz3n82fkYhAavqymbs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)