UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'w9hHfoRk6b6rriEu8Evp5J2cD8BZ8KTRTTFTioTTXgM='
WHERE
key_id = '3ff2a85eef9bcac672bb0f4df2eac4df644fc012b19d23a63e4f7cddbf02ee3b'
AND (
token = 'w9hHfoRk6b6rriEu8Evp5J2cD8BZ8KTRTTFTioTTXgM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)