UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'H5pRQWRPlm7Rx3jzVVstXer1MRpvJ/eZW3bIZrWsSsE='
WHERE
key_id = 'a31216aee4df3f85ca3f5923c62db7ffa854f7561bf584981e2c3940caf8e96e'
AND (
token = 'H5pRQWRPlm7Rx3jzVVstXer1MRpvJ/eZW3bIZrWsSsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)