UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WKEbm6YHxZLlMmMboTlxI0NZKedfNTm0msfUL8bhBYo='
WHERE
key_id = 'f39c50b9e29e0bbd9d8bc8556702863cd66c753580c274bda9447a6fc87681ad'
AND (
token = 'WKEbm6YHxZLlMmMboTlxI0NZKedfNTm0msfUL8bhBYo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)