UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vvN0ugtrHFVfOycxhsWfdZn652t3mrFzteRC7Zt5P0k='
WHERE
key_id = '7a8cad25b825a9a1ddea8880baa1d8a6900cd810532c5e5c242c90d10c357c3d'
AND (
token = 'vvN0ugtrHFVfOycxhsWfdZn652t3mrFzteRC7Zt5P0k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)