UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/y/To86u8NxxxjZa4waonvh+oDx+0gg00krG+9KZPsE='
WHERE
key_id = 'c594be398c4df3d5a8c8c7a945527e4226c04e8a8d114eeb1cda1d6d337732ec'
AND (
token = '/y/To86u8NxxxjZa4waonvh+oDx+0gg00krG+9KZPsE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)