UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KXj+gCNRGv2JVENCL3ChoXCG8oJzyoB0W7WFkAcqCec='
WHERE
key_id = '18368bca0ca71e298d74d6484b0493ec61b0d0199b98cea956d141fab6128f97'
AND (
token = 'KXj+gCNRGv2JVENCL3ChoXCG8oJzyoB0W7WFkAcqCec='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)