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