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