UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HP5cnrf6rUdj14yn2VNfRf/CKeff876KPO6VwYItyGw='
WHERE
key_id = 'bbc9407a4db50cd22469ef12b4e0a2ff6517fd10ee8ac7b183853e9b10af08d8'
AND (
token = 'HP5cnrf6rUdj14yn2VNfRf/CKeff876KPO6VwYItyGw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)