UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yG8WBVN7j4epfHZdvnVOQUoxqPUkkr7jyQSFCztLVmw='
WHERE
key_id = '74a45a89cef38c8c103f7a165730994bb4ada0ad4cc44ea6420cf0b212d6060f'
AND (
token = 'yG8WBVN7j4epfHZdvnVOQUoxqPUkkr7jyQSFCztLVmw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)