UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/V01xxNGHqe7ATYRZ8mwjg6ftwWRXtc1Rd/kyabF2m8='
WHERE
key_id = '9e017e8b4ec72fd1d28af0634289c565159011a7b174dbbc1d2971962a9b510d'
AND (
token = '/V01xxNGHqe7ATYRZ8mwjg6ftwWRXtc1Rd/kyabF2m8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)