UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8pjHYrlbqg58e/c7wy4nTvC1Y/ONwCqKmZP5vRyjKa0='
WHERE
key_id = '2b67ef1549b942bd09c43cccc011e7609463a5f488236a8a4984cbca66d42f2f'
AND (
token = '8pjHYrlbqg58e/c7wy4nTvC1Y/ONwCqKmZP5vRyjKa0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)