UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UP0gRHViO6/PbaJpfixIAGed6baFZiyqx452hLVfwN0='
WHERE
key_id = '3c7e19faf88a40d7a786fceaf96633a0d83b0e58a18f4ab7551a7a964a4ae758'
AND (
token = 'UP0gRHViO6/PbaJpfixIAGed6baFZiyqx452hLVfwN0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)