UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bti46b1wmZC8N2Pbq6IO6/8lABjRF14eX+XMGTMe/4o='
WHERE
key_id = '4d9482ed88dfc65b35ac76e736270ad87bf5e2f731f4eebd2aabc9c90dd54f0c'
AND (
token = 'bti46b1wmZC8N2Pbq6IO6/8lABjRF14eX+XMGTMe/4o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)