UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P3/uYbsGWqmhf87UTdpohPcOFWAqJmIi0klp0cD1Tzc='
WHERE
key_id = '89df66f75f4597f816b25d9ec9878a989f18d45d5c3c2a0d0e14c6270d95f447'
AND (
token = 'P3/uYbsGWqmhf87UTdpohPcOFWAqJmIi0klp0cD1Tzc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)