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