UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+/2J36GUPitwqb9zie3ZCjbqGwmKUgb5F0Fg5Bsy5bw='
WHERE
key_id = '05bdfb5f4dcce2e6872183b93dc03d253b644c50c4a742729a67691a12969f9e'
AND (
token = '+/2J36GUPitwqb9zie3ZCjbqGwmKUgb5F0Fg5Bsy5bw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)