UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KW22zBPYvmTSMqGn+eMyu8OpknUHojc/ZEHx5J6XYc8='
WHERE
key_id = 'f0431c2ab8622de38fe9f170b47787f2b7819af33d3837ebda50e06dd0ef11b3'
AND (
token = 'KW22zBPYvmTSMqGn+eMyu8OpknUHojc/ZEHx5J6XYc8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)