UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xDgvxx34C2Ebe7ndnrX82daXH/JZbBqHdpZeMO7gVTE='
WHERE
key_id = 'bd669404b855d3688e2d9e876c67e3555a8e4732f37b78d7520aab141daef57b'
AND (
token = 'xDgvxx34C2Ebe7ndnrX82daXH/JZbBqHdpZeMO7gVTE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)