UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8v4Ka55Vfdi7CF1W7EE7xBBFY4935LGH4Zy45B1aZHw='
WHERE
key_id = 'c04dc394e1d28bdbab5db09b5bd6c4664a763f734aa64f9ac55f0d4bd246b7b9'
AND (
token = '8v4Ka55Vfdi7CF1W7EE7xBBFY4935LGH4Zy45B1aZHw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)