UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'vC0CyLM5+KreO+7kykiA2ufvUmLBLJk7aMpouKo9FGI='
WHERE
key_id = 'e4b26ab07a6028d4da76b19740356cee658f72717fb71d9320d66cf765087249'
AND (
token = 'vC0CyLM5+KreO+7kykiA2ufvUmLBLJk7aMpouKo9FGI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)