UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZAv4VrJw0Tm+o447G2SfNSssJtlwyEOtqi0nV92AAvw='
WHERE
key_id = '7afaf47dceb78ac0ed5d9bcced247f985e924060c992c1a92a29452fe2407ef6'
AND (
token = 'ZAv4VrJw0Tm+o447G2SfNSssJtlwyEOtqi0nV92AAvw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)