UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KNH5Xc8NdtAl/J0UKAMF4n46IFJRPzto55U4FQCRVN4='
WHERE
key_id = '96bd62abf25615d5a7df37a7dd6ec7a580c4771cb94903301e17c243c55bbfa4'
AND (
token = 'KNH5Xc8NdtAl/J0UKAMF4n46IFJRPzto55U4FQCRVN4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)