UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wlNtU4A1EbyE7qH5erk1pSMHB3bILCT9K3bYsUJrHO0='
WHERE
key_id = '8a591b7e598548b19cc4b1f70ec8ae146fc765496dc87d16945b7dde9803c85d'
AND (
token = 'wlNtU4A1EbyE7qH5erk1pSMHB3bILCT9K3bYsUJrHO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)