UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ko+7mC2e24OPRgB5bz+1AkzGEuc20jSy6Rfm9Awv8MI='
WHERE
key_id = 'f8c3ab96eee5e6114f1212daf2cc5a7c8a2cbcce7598ea76a6e6fb61ac18913d'
AND (
token = 'ko+7mC2e24OPRgB5bz+1AkzGEuc20jSy6Rfm9Awv8MI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)