UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HmZzU8yxLuvLDusu+KgeKEVYsbGPLIXgZCNPrThw8tM='
WHERE
key_id = '2a7fa514d99434966c3f87d47becf201519507dd32fa0ff566f35611c9221742'
AND (
token = 'HmZzU8yxLuvLDusu+KgeKEVYsbGPLIXgZCNPrThw8tM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)