UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNNLr1F3PFgg3CvoDOVZRuDLgXmyjKAipxz6nuo33RM='
WHERE
key_id = 'c31d5a181260144f1f01d12eb0e9360eee66789840e978cc352fbc9ceb46c03f'
AND (
token = 'ZNNLr1F3PFgg3CvoDOVZRuDLgXmyjKAipxz6nuo33RM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)