UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Rodx8ShvAgC6uRrVkySOZUZ1q8Slu9r0ICxF8bOklq0='
WHERE
key_id = '4e01e38cc51a78914d44c31d1f2b8229ae6f5308eea2c29770f4fe560c391899'
AND (
token = 'Rodx8ShvAgC6uRrVkySOZUZ1q8Slu9r0ICxF8bOklq0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)