UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JoAHJH5PcCKZTie46TK+a1yc6baH6s82/qQwTkNtPkI='
WHERE
key_id = 'ddbe49c7ff64cbab0a329490b912111298fc338f4d907936230c0be11c50a2c6'
AND (
token = 'JoAHJH5PcCKZTie46TK+a1yc6baH6s82/qQwTkNtPkI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)