UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bLuY3gznY6V3y26pc7+wRwt8nc3Hp6f2zTW4LD0c6HU='
WHERE
key_id = 'c9923a6e642a869a15abb83576cb9b98b48c0da67d5c6edc806c449edcf50f01'
AND (
token = 'bLuY3gznY6V3y26pc7+wRwt8nc3Hp6f2zTW4LD0c6HU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)