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