UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pi30gzIQjVE5GS1R4v7eDmf6G4LF3T7juJ7ECmApQjE='
WHERE
key_id = '6d82f86255b16d5c3e97fdd85072813bfcf4cb9031b1151858c786ce4a79b4c4'
AND (
token = 'pi30gzIQjVE5GS1R4v7eDmf6G4LF3T7juJ7ECmApQjE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)