UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hLan8p5GavfmYGdN6ivJVtvyoYRxCholH+zAZHHjtz8='
WHERE
key_id = '21c3a08ada61cbeb23d2982849b03eaa06321182fb1d4b77efe63c133a7b4577'
AND (
token = 'hLan8p5GavfmYGdN6ivJVtvyoYRxCholH+zAZHHjtz8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)